Ryan Sides Community Champion

Overview

Overview

Email	rsides27@gmail.com
Roles	Member
Badges	25

About Me

About Me

Area of Expertise	Business Process Improvement; using Smartsheet to it's full capabilities. Control Center, Data Shuttle/Mesh, Dynamic View, Resource Management, and others.
About Me	I help organizations of various sizes get the most from their Smartsheet licenses.
How I Use Smartsheet	As a consultant helping others. Feel free to drop me a line. I'm always glad to help!
Linkedin	https://www.linkedin.com/in/business-operations-consultant-coach/

Analytics

516

Posts

540

Visits

1.6k

Points

May 31, 2022

Join Date

Feb 27, 2025

Last Active

Reactions

• Insightful 11

  11
• Vote Up 29

  29
• Awesome 56

  56
• Spam 2

  2

• Activity
• Discussions9
• Comments507

• Re: How do I count multiple types in a column?

  Ryan Sides

  12/08/22
  Hi @nicoleejordannn If your Quarter column has various values, you'll need the OR operator to check to see if QUARTER has "Q1'23" or "Q2'23" or... =COUNTIFS({STATUS}, "Comple…
  1 ·

• Re: What is the formula to check box from value in another column?

  Ryan Sides

  01/16/23
  =if(Or(Column@row = "N/A", Column@row = "Complete"), 1, 0) Like that?
  1 ·

• Re: Spreadsheet and Intake Form

  Ryan Sides

  12/14/22
  Hi @Missy Thompson Great question! And a great place to get started as a new user. I recorded this video which explains everything in detail for you. (Creating the Sheet, Adding the Form and creating…
  1 ·

• Re: Parent Row to display Child Row value based on upcoming due date

  Ryan Sides

  12/14/22
  @Luke W. You'll need to use INDEX/MATCH formula combo to find the CHILDREN. Place this on the parent row in the VNT column =INDEX(CHILDREN(), MATCH([VNT Due]@row, CHILDREN([VNT Due]@row), 0))
  1 ·

• Re: Counting Unique Values Based on Request Type.

  Ryan Sides

  12/14/22
  Hey @Brett Hughes , You're on the right track. We need to use COUNT DISTINCT COLLECT function combo... =COUNT(DISTINCT(COLLECT({Completion Updates Range 10}, {Completion Updates Range 7}, "Other…
  2 ·

Previous Next